SELECT current_plan_package,business_name,
business_id,
big_description,
small_description,
address1,
address2,
building_name,
area, city,
nearest_busstop,
state,
country,
zipcode, seo_url FROM bd_business_description WHERE mirror='0' AND status='1' AND city='Lekki' AND state='Rivers' AND country='Nigeria' AND business_id IN( SELECT business_id FROM bd_business_category WHERE category_id IN (SELECT CategoryID FROM bd_category WHERE Name='Opticians & Eye Care') ) ORDER BY current_plan_package DESC
Address: No 9 Rumuogba Estate Ph, Lekki, Rivers, Nigeria
This specialized eye care facility provides a comprehensive range of optical services to ensure optimal visual health. They offer professional eye examinations, precision lens fitting, and a diverse selection of frames to suit individual lifestyle needs. more
Address: No 9 Rumuogba Estate Ph, Lekki, Rivers, Nigeria
This specialized eye care facility provides a comprehensive range of optical services to ensure optimal visual health. They offer professional eye examinations, precision lens fitting, and a diverse selection of frames to suit individual lifestyle needs. more
Print
Email
Error tell us?
Claim this business